package com.example.demo.mapper;

import com.example.demo.entity.Source;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface LinearMapper {

    @Select("select stu_class,AVG(gpa) as avgGpa from dashuju GROUP BY stu_class ORDER BY AVG(gpa) asc")
    List<Source> getDashujuLinear();

    @Select("select stu_class,AVG(gpa) as avgGpa from jisuanjiyingyong GROUP BY stu_class ORDER BY AVG(gpa) asc ")
    List<Source> getJisuanjiyingyongLinear();//计算机应用

    @Select("select stu_class,AVG(gpa) as avgGpa from ruanjiangongcheng GROUP BY stu_class ORDER BY AVG(gpa) asc ")
    List<Source> getRuanjiangongchengLinear();//软件工程

    @Select("select stu_class,AVG(gpa) as avgGpa from ruanjianjishu GROUP BY stu_class ORDER BY AVG(gpa) asc ")
    List<Source> getRuanjianjishuLinear();//软件技术

    @Select("select stu_class,AVG(gpa) as avgGpa from wangluogongcheng GROUP BY stu_class ORDER BY AVG(gpa) asc ")
    List<Source> getWangluogongchengLinear();//网络工程

    @Select("select stu_class,AVG(gpa) as avgGpa from wangluojishu GROUP BY stu_class ORDER BY AVG(gpa) asc ")
    List<Source> getWangluojishuLinear();//网络技术

    @Select("select stu_class,AVG(gpa) as avgGpa from wulianwang GROUP BY stu_class ORDER BY AVG(gpa) asc ")
    List<Source> getWulianwangLinear();//物联网

    @Select("select stu_class,AVG(gpa) as avgGpa from xinxiguanli GROUP BY stu_class ORDER BY AVG(gpa) asc ")
    List<Source> getXinxiguanliLinear();//信息管理
}
